package meta

var sqlInsertConf = `
INSERT INTO meta_conf_#tenant_id (key, value, vtype) VALUES (@key, @value, @vtype);
`
var sqlGetConfByKey = `
SELECT id, key, value, vtype, created_at, updated_at FROM meta_conf_#tenant_id WHERE key = @key;
`

var sqlGetConf = "SELECT id, `key`, `value`, vtype, created_at, updated_at FROM meta_conf_#tenant_id;"

var sqlUpdateConf = `
UPDATE meta_conf_#tenant_id SET value = @value, vtype = @vtype WHERE key = @key AND tenant_id = #tenant_id;
`

var sqlDeleteConf = `
DELETE FROM meta_conf_#tenant_id WHERE key = @key AND tenant_id = #tenant_id;
`
